{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["BSC","BSC-CUADRO","ANALISIS","PLANEACION","ADMINISTRATIVA","PRODUCCION","GESTION DE CALIDAD","COMUNICACION","MANTENIMIENTO","CONTROL INTERNO","GESTIÓN TECNOLOGICA","COMERCIALIZACIÓN","JURIDICA","FINANCIERA","CONTROL DE CALIDAD"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BSC","index":0,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,1,10],[2,0,2,9],[0,0,0,9]]}
["INDUSTRIA  LICORERA DEL CAUCA"]
["BSC-CUADRO DE MANDO INTEGRAL"]
["PROCESOS"]

{"sheet":"BSC-CUADRO","index":1,"n_rows":33,"n_cols":29,"rows_kept":33,"cut":false,"hidden":true,"merged":[[13,0,14,0],[7,0,8,0],[28,6,28,7],[28,0,28,5],[22,0,22,13],[24,0,26,0],[31,0,32,0],[22,17,22,18],[9,0,10,0],[1,0,3,0],[0,1,0,28],[1,1,1,28],[2,1,3,2],[2,3,3,6],[2,7,3,11],[2,12,3,16],[2,17,3,28],[4,0,4,28],[5,27,5,28],[19,0,20,0],[21,0,21,16383],[5,0,5,25]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03\n",null,"Versión\n04\n",null,null,null,"Fecha vigencia\nJulio  16 de 2018\n",null,null,null,null,"Página \n1 de 13\n"]
[]
[]
["MENSUAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANUAL"]
["PROCESOS","INDICADOR","ENE","META","FEB.","META","MAR.","META","ABR.","META","MAY.","META","JUN.","META","JUL.","META","AGO.","META","SEP.","META","OCT.","META","NOV.","META","DIC.","META",null,"AÑO","META"]
["PRODUCCION","PLAN DE PRODUCCIÓN",{"$f":"PRODUCCION!E8","v":0},{"$f":"IF(C8>=80%,1,0)","v":0},{"$f":"PRODUCCION!G8","v":3.1075757575757576E-2},{"$f":"IF(E8>=80%,1,0)","v":0},{"$f":"PRODUCCION!I8","v":0.31958508158508159},{"$f":"IF(G8>=80%,1,0)","v":0},{"$f":"PRODUCCION!K8","v":0.32133522727272729},{"$f":"IF(I8>=80%,1,0)","v":0},{"$f":"PRODUCCION!M8","v":0.33410685090448816},{"$f":"IF(K8>=80%,1,0)","v":0},{"$f":"PRODUCCION!O8","v":0.99804000000000004},{"$f":"IF(M8>=80%,1,0)","v":1},{"$f":"PRODUCCION!Q8","v":0.98765931372549021},{"$f":"IF(O8>=80%,1,0)","v":1},{"$f":"PRODUCCION!S8","v":0.80706630675895985},{"$f":"IF(Q8>=80%,1,0)","v":1},{"$f":"PRODUCCION!U8","v":11.661818181818182},{"$f":"IF(S8>=80%,1,0)","v":1},{"$f":"PRODUCCION!W8","v":1},{"$f":"IF(U8>=80%,1,0)","v":1},{"$f":"PRODUCCION!Y8","v":1},{"$f":"IF(W8>=80%,1,0)","v":1},{"$f":"PRODUCCION!AA8","v":1},{"$f":"IF(Y8>=80%,1,0)","v":1},null,{"$f":"PRODUCCION!AB8","v":1.5383905599700574},{"$f":"IF(AB8>=70%,1,0)","v":1}]
[null,"REDUCIR EL IMPACTO AMBIENTAL EN EL MANEJO DE LOS RESIDUOS DE LA PRODUCCIÓN",{"$f":"PRODUCCION!E11","v":{"$error":"#DIV/0!"}},{"$f":"IF(C9>=1.5%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"PRODUCCION!G11","v":1.9941491955143831E-2},{"$f":"IF(E9>=1.5%,1,0)","v":1},{"$f":"PRODUCCION!I11","v":1.0138437076045573E-2},{"$f":"IF(G9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!K11","v":4.2362891580467387E-3},{"$f":"IF(I9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!M11","v":6.7175304744365519E-3},{"$f":"IF(K9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!O11","v":4.6491122600296579E-3},{"$f":"IF(M9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!Q11","v":4.1442805206407503E-3},{"$f":"IF(O9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!S11","v":3.2259310771132746E-3},{"$f":"IF(Q9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!U11","v":2.9414821744101444E-3},{"$f":"IF(S9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!W11","v":6.7301742957540951E-3},{"$f":"IF(U9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!Y11","v":6.1274509803921568E-3},{"$f":"IF(W9>=1.5%,1,0)","v":0},{"$f":"PRODUCCION!AA11","v":4.5728419205936068E-3},{"$f":"IF(Y9>=1.5%,1,0)","v":0}]
["SGC","ESTADO DE ACCIONES CORRECTIVAS",{"$f":"'GESTION DE CALIDAD'!E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!G7","v":{"$error":"#DIV/0!"}},{"$f":"IF(E10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!I7","v":{"$error":"#DIV/0!"}},{"$f":"IF(G10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!K7","v":{"$error":"#DIV/0!"}},{"$f":"IF(I10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!M7","v":{"$error":"#DIV/0!"}},{"$f":"IF(K10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!O7","v":{"$error":"#DIV/0!"}},{"$f":"IF(M10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!Q7","v":{"$error":"#DIV/0!"}},{"$f":"IF(O10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!S7","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!U7","v":{"$error":"#DIV/0!"}},{"$f":"IF(S10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!W7","v":{"$error":"#DIV/0!"}},{"$f":"IF(U10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!Y7","v":{"$error":"#DIV/0!"}},{"$f":"IF(W10>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!AA7","v":1},{"$f":"IF(Y10>=70%,1,0)","v":1}]
[null,"AUDITORIA INTERNA",{"$f":"'GESTION DE CALIDAD'!E9","v":{"$error":"#DIV/0!"}},{"$f":"IF(C11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!G9","v":{"$error":"#DIV/0!"}},{"$f":"IF(E11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!I9","v":{"$error":"#DIV/0!"}},{"$f":"IF(G11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!K9","v":{"$error":"#DIV/0!"}},{"$f":"IF(I11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!M9","v":{"$error":"#DIV/0!"}},{"$f":"IF(K11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!O9","v":{"$error":"#DIV/0!"}},{"$f":"IF(M11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!Q9","v":{"$error":"#DIV/0!"}},{"$f":"IF(O11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!S9","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!U9","v":{"$error":"#DIV/0!"}},{"$f":"IF(S11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!W9","v":{"$error":"#DIV/0!"}},{"$f":"IF(U11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!Y9","v":{"$error":"#DIV/0!"}},{"$f":"IF(W11>=70%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'GESTION DE CALIDAD'!AA9","v":1},{"$f":"IF(Y11>=70%,1,0)","v":1},null,{"$f":"SUM(C11,E11,G11,I11,K11,M11,O11,Q11,S11,U11,W11,Y11)","v":{"$error":"#DIV/0!"}},{"$f":"IF(AB11>=70%,1,0)","v":{"$error":"#DIV/0!"}}]
["MANTENIMIENTO","% DISPONIBILIDAD",{"$f":"MANTENIMIENTO!E7","v":1},{"$f":"IF(C12<70%,\"malo\",IF(C12<79%,\"regular\",IF(C12<89%,\"bueno\",IF(C12<95%,\"optimo\",IF(C12>=95%,\"fuera de rango\",\" \")))))","v":"fuera de rango"},{"$f":"MANTENIMIENTO!G7","v":0.67458866544789764},{"$f":"IF(E12<70%,\"malo\",IF(E12<79%,\"regular\",IF(E12<89%,\"bueno\",IF(E12<95%,\"optimo\",IF(E12>=95%,\"fuera de rango\",\" \")))))","v":"malo"},{"$f":"MANTENIMIENTO!I7","v":0.79057239057239059},{"$f":"IF(G12<70%,\"malo\",IF(G12<79%,\"regular\",IF(G12<89%,\"bueno\",IF(G12<95%,\"optimo\",IF(G12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!K7","v":0.78871284838672373},{"$f":"IF(I12<70%,\"malo\",IF(I12<79%,\"regular\",IF(I12<89%,\"bueno\",IF(I12<95%,\"optimo\",IF(I12>=95%,\"fuera de rango\",\" \")))))","v":"regular"},{"$f":"MANTENIMIENTO!M7","v":0.88566350710900477},{"$f":"IF(K12<70%,\"malo\",IF(K12<79%,\"regular\",IF(K12<89%,\"bueno\",IF(K12<95%,\"optimo\",IF(K12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!O7","v":0.838409040874734},{"$f":"IF(M12<70%,\"malo\",IF(M12<79%,\"regular\",IF(M12<89%,\"bueno\",IF(M12<95%,\"optimo\",IF(M12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!Q7","v":0.9104968739717012},{"$f":"IF(O12<70%,\"malo\",IF(O12<79%,\"regular\",IF(O12<89%,\"bueno\",IF(O12<95%,\"optimo\",IF(O12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"},{"$f":"MANTENIMIENTO!S7","v":0.87124922090641976},{"$f":"IF(Q12<70%,\"malo\",IF(Q12<79%,\"regular\",IF(Q12<89%,\"bueno\",IF(Q12<95%,\"optimo\",IF(Q12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!U7","v":0.89568045994402001},{"$f":"IF(S12<70%,\"malo\",IF(S12<79%,\"regular\",IF(S12<89%,\"bueno\",IF(S12<95%,\"optimo\",IF(S12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"},{"$f":"MANTENIMIENTO!W7","v":0.82418960436390998},{"$f":"IF(U12<70%,\"malo\",IF(U12<79%,\"regular\",IF(U12<89%,\"bueno\",IF(U12<95%,\"optimo\",IF(U12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!Y7","v":0.83314694699172442},{"$f":"IF(W12<70%,\"malo\",IF(W12<79%,\"regular\",IF(W12<89%,\"bueno\",IF(W12<95%,\"optimo\",IF(W12>=95%,\"fuera de rango\",\" \")))))","v":"bueno"},{"$f":"MANTENIMIENTO!AA7","v":0.8910497397339503},{"$f":"IF(Y12<70%,\"malo\",IF(Y12<79%,\"regular\",IF(Y12<89%,\"bueno\",IF(Y12<95%,\"optimo\",IF(Y12>=95%,\"fuera de rango\",\" \")))))","v":"optimo"}]
["CONTROL INTERNO","AUDITORIA INTERNA ",{"$f":"'CONTROL INTERNO'!E7","v":0},{"$f":"IF(C13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!G7","v":0},{"$f":"IF(E13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!I7","v":0},{"$f":"IF(G13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!K7","v":0.33333333333333331},{"$f":"IF(I13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!M7","v":0.33333333333333331},{"$f":"IF(K13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!O7","v":0.33333333333333331},{"$f":"IF(M13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!Q7","v":0},{"$f":"IF(O13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!S7","v":0},{"$f":"IF(Q13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!U7","v":0},{"$f":"IF(S13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!W7","v":0},{"$f":"IF(U13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!Y7","v":0},{"$f":"IF(W13>=80%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!AA7","v":0},{"$f":"IF(Y13>=80%,1,0)","v":0}]
["ADMINISTRATIVA","ALMACENAMIENTO DE CLIENTES ",{"$f":"ADMINISTRATIVA!E7","v":0.20283999999999999},{"$f":"IF(C14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!G7","v":0.13773333333333335},{"$f":"IF(E14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!I7","v":0.12539333333333333},{"$f":"IF(G14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!K7","v":0.10828},{"$f":"IF(I14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!M7","v":0.10435333333333334},{"$f":"IF(K14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!O7","v":9.2193333333333335E-2},{"$f":"IF(M14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Q7","v":6.0600000000000001E-2},{"$f":"IF(O14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!S7","v":4.4290000000000003E-2},{"$f":"IF(Q14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!U7","v":3.2953333333333334E-2},{"$f":"IF(S14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!W7","v":2.9466666666666665E-2},{"$f":"IF(U14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Y7","v":3.8089999999999999E-2},{"$f":"IF(W14<=33%,1,0)","v":1},{"$f":"ADMINISTRATIVA!AA7","v":0.33},{"$f":"IF(Y14<=33%,1,0)","v":1}]
[null,"SGSST",{"$f":"ADMINISTRATIVA!E9","v":1},{"$f":"IF(C15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!G9","v":1},{"$f":"IF(E15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!I9","v":1},{"$f":"IF(G15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!K9","v":1},{"$f":"IF(I15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!M9","v":1},{"$f":"IF(K15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!O9","v":0.78947368421052633},{"$f":"IF(M15=100%,1,0)","v":0},{"$f":"ADMINISTRATIVA!Q9","v":1},{"$f":"IF(O15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!S9","v":1},{"$f":"IF(Q15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!U9","v":0.88888888888888884},{"$f":"IF(S15=100%,1,0)","v":0},{"$f":"ADMINISTRATIVA!W9","v":1},{"$f":"IF(U15=100%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Y9","v":0.8571428571428571},{"$f":"IF(W15=100%,1,0)","v":0},{"$f":"ADMINISTRATIVA!AA9","v":0.96644295302013428},{"$f":"IF(Y15=100%,1,0)","v":0}]
["TECNOLOGIA DE LA INFORMACION\nY LA COMUNICACIÓN","SOPORTE",{"$f":"'GESTIÓN TECNOLOGICA'!E7","v":1},{"$f":"IF(C16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!G7","v":1},{"$f":"IF(E16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!I7","v":1},{"$f":"IF(G16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!K7","v":1},{"$f":"IF(I16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!M7","v":1},{"$f":"IF(K16<=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!O7","v":1},{"$f":"IF(M16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!Q7","v":1},{"$f":"IF(O16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!S7","v":1},{"$f":"IF(Q16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!U7","v":1},{"$f":"IF(S16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!W7","v":1},{"$f":"IF(U16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!Y7","v":1},{"$f":"IF(W16>=100%,1,0)","v":1},{"$f":"'GESTIÓN TECNOLOGICA'!AA7","v":1},{"$f":"IF(Y16>=100%,1,0)","v":1}]
["COMERCIALIZACION","VENTAS",{"$f":"COMERCIALIZACIÓN!E7","v":0},{"$f":"IF(C17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!G7","v":9.3996875000000001E-3},{"$f":"IF(E17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!I7","v":3.7306875000000003E-2},{"$f":"IF(G17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!K7","v":9.5217499999999997E-2},{"$f":"IF(I17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!M7","v":0.16313875},{"$f":"IF(K17>=40%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!O7","v":0.24762218750000001},{"$f":"IF(M17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!Q7","v":0.33286874999999999},{"$f":"IF(O17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!S7","v":0.42262156249999999},{"$f":"IF(Q17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!U7","v":0.48550343750000002},{"$f":"IF(S17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!W7","v":0.58779531249999994},{"$f":"IF(U17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!Y7","v":0.67906968749999996},{"$f":"IF(W17>=100%,1,0)","v":0},{"$f":"COMERCIALIZACIÓN!AA7","v":1.0016546875000001},{"$f":"IF(Y17>=100%,1,0)","v":1},null,{"$f":"SUM(C17,E17,G17,I17,K17,M17,O17,Q17,S17,U17,W17,Y17)","v":4.0621984375000002},{"$f":"IF(AB17>=100%,1,0)","v":1}]
["JURIDICA","CONTRATOS OPORTUNOS",{"$f":"JURIDICA!E7","v":1},{"$f":"IF(C18>=100%,1,0)","v":1},{"$f":"JURIDICA!G7","v":1},{"$f":"IF(E18>=100%,1,0)","v":1},{"$f":"JURIDICA!I7","v":1},{"$f":"IF(G18>=100%,1,0)","v":1},{"$f":"JURIDICA!K7","v":1},{"$f":"IF(I18>=100%,1,0)","v":1},{"$f":"JURIDICA!M7","v":1},{"$f":"IF(K18>=100%,1,0)","v":1},{"$f":"JURIDICA!O7","v":1},{"$f":"IF(M18>=100%,1,0)","v":1},{"$f":"JURIDICA!Q7","v":1},{"$f":"IF(O18>=100%,1,0)","v":1},{"$f":"JURIDICA!S7","v":1},{"$f":"IF(Q18>=100%,1,0)","v":1},{"$f":"JURIDICA!U7","v":1},{"$f":"IF(S18>=100%,1,0)","v":1},{"$f":"JURIDICA!W7","v":1},{"$f":"IF(U18>=100%,1,0)","v":1},{"$f":"JURIDICA!Y7","v":1},{"$f":"IF(W18>=100%,1,0)","v":1},{"$f":"JURIDICA!AA7","v":1},{"$f":"IF(Y18>=100%,1,0)","v":1}]
["FINANCIERA","MARGEN OPERACIONAL",{"$f":"FINANCIERA!E7","v":{"$error":"#DIV/0!"}},{"$f":"IF(C19>=17%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"FINANCIERA!G7","v":4.7988396439919407},{"$f":"IF(E19>=17%,1,0)","v":1},{"$f":"FINANCIERA!I7","v":1.3668240578658952},{"$f":"IF(G19>=17%,1,0)","v":1},{"$f":"FINANCIERA!K7","v":0.37286537232047817},{"$f":"IF(I19>=17%,1,0)","v":1},{"$f":"FINANCIERA!M7","v":6.971558941598964E-2},{"$f":"IF(K19>=17%,1,0)","v":0},{"$f":"FINANCIERA!O7","v":-1.6922716543432567E-2},{"$f":"IF(M19>=17%,1,0)","v":0},{"$f":"FINANCIERA!Q7","v":3.4427806807830558E-2},{"$f":"IF(O19>=17%,1,0)","v":0},{"$f":"FINANCIERA!S7","v":7.140994074981323E-2},{"$f":"IF(Q19>=17%,1,0)","v":0},{"$f":"FINANCIERA!U7","v":0.10688355931691895},{"$f":"IF(S19>=17%,1,0)","v":0},{"$f":"FINANCIERA!W7","v":0.14928610549871199},{"$f":"IF(U19>=17%,1,0)","v":0},{"$f":"FINANCIERA!Y7","v":0.17612968106950672},{"$f":"IF(W19>=17%,1,0)","v":1},{"$f":"FINANCIERA!AA7","v":0.26075781570378248},{"$f":"IF(Y19>=17%,1,0)","v":1}]
["CONTROL DE CALIDAD","RECLAMOS ATENDIDOS",{"$f":"'CONTROL DE CALIDAD'!E7","v":1},{"$f":"IF(C20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!G7","v":1},{"$f":"IF(E20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!I7","v":1},{"$f":"IF(G20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!K7","v":1},{"$f":"IF(I20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!M7","v":1},{"$f":"IF(K20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!O7","v":1},{"$f":"IF(M20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Q7","v":1},{"$f":"IF(O20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!S7","v":{"$error":"#DIV/0!"}},{"$f":"IF(Q20=100%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'CONTROL DE CALIDAD'!U7","v":1},{"$f":"IF(S20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!W7","v":1},{"$f":"IF(U20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Y7","v":1},{"$f":"IF(W20=100%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!AA7","v":1},{"$f":"IF(Y20=100%,1,0)","v":1}]
[null,"PRODUCTOS NO CONFORMES",{"$f":"'CONTROL DE CALIDAD'!E10","v":0},{"$f":"IF(C21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!G10","v":7.6723163841807912E-2},{"$f":"IF(E21<=3%,1,0)","v":0},{"$f":"'CONTROL DE CALIDAD'!I10","v":9.784755737471236E-3},{"$f":"IF(G21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!K10","v":8.9871818765401429E-3},{"$f":"IF(I21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!M10","v":3.1838753815387854E-3},{"$f":"IF(K21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!O10","v":2.1442747432910518E-3},{"$f":"IF(M21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Q10","v":2.8470663449007478E-3},{"$f":"IF(O21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!S10","v":2.4801862218034694E-3},{"$f":"IF(Q21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!U10","v":1.590248208536712E-3},{"$f":"IF(S21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!W10","v":2.0254999786789474E-3},{"$f":"IF(U21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!Y10","v":8.9860609920045277E-3},{"$f":"IF(W21<=3%,1,0)","v":1},{"$f":"'CONTROL DE CALIDAD'!AA10","v":3.073159508482296E-3},{"$f":"IF(Y21<=3%,1,0)","v":1}]
[]
["BIMESTRAL"]
["PROCESOS","INDICADOR","1 BIMESTRE","META","2 BIMESTRE","META","3 BIMESTRE","META","4 BIMESTRE","META","5 BIMESTRE","META","6 BIMESTRE","META"]
["CONTROL INTERNO","ENTES EXTERNOS",{"$f":"'CONTROL INTERNO'!E11","v":1},{"$f":"IF(C25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!G11","v":1},{"$f":"IF(E25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!I11","v":{"$error":"#DIV/0!"}},{"$f":"IF(G25=100%,1,0)","v":{"$error":"#DIV/0!"}},{"$f":"'CONTROL INTERNO'!K11","v":1},{"$f":"IF(I25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!M15","v":1},{"$f":"IF(K25=100%,1,0)","v":1},{"$f":"'CONTROL INTERNO'!O15","v":1},{"$f":"IF(M25=100%,1,0)","v":1}]
[null,"ENTES EXTERNOS",{"$f":"'CONTROL INTERNO'!E12","v":0},{"$f":"IF(C26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!G12","v":0},{"$f":"IF(E26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!I12","v":0},{"$f":"IF(G26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!K12","v":0},{"$f":"IF(I26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!M16","v":0},{"$f":"IF(K26=100%,1,0)","v":0},{"$f":"'CONTROL INTERNO'!O16","v":0},{"$f":"IF(M26=100%,1,0)","v":0}]
[null,"SIA",{"$f":"'CONTROL INTERNO'!E15","v":1},1,{"$f":"'CONTROL INTERNO'!G15","v":1},1,{"$f":"'CONTROL INTERNO'!I15","v":1},1,{"$f":"'CONTROL INTERNO'!K15","v":1},1,{"$f":"'CONTROL INTERNO'!M15","v":1},1,{"$f":"'CONTROL INTERNO'!O15","v":1},1]
[]
["SEMESTRAL",null,null,null,null,null,"ANUAL"]
["PROCESOS","INDICADOR","1 \nSEMESTRE","META","2 \nSEMESTRE","META","AÑO","META"]
["ADMINISTRATIVA","CAPACITACION",{"$f":"ADMINISTRATIVA!N11","v":0.5},{"$f":"IF(C31>=50%,1,0)","v":1},{"$f":"ADMINISTRATIVA!Z11","v":0.3235294117647059},{"$f":"IF(E31>=50%,1,0)","v":0},{"$f":"IF(SUM(C31,E31)>=100%,100%,SUM(C31,E31))","v":0.82352941176470584},{"$f":"IF(G31=100%,1,0)","v":0}]
["PLANEACIÓN","PROYECTOS",{"$f":"PLANEACION!E7","v":1},{"$f":"IF(C32>=90%,1,0)","v":1},{"$f":"PLANEACION!G7","v":1},{"$f":"IF(E32>=90%,1,0)","v":1},{"$f":"AVERAGE(C32,E32)","v":1},{"$f":"IF(G32>=90%,1,0)","v":1}]
[null,"FORMULACION PLAN ESTRATEGICO 2019-2022",{"$f":"PLANEACION!E9","v":1},{"$f":"IF(C33>=50%,1,0)","v":1},{"$f":"PLANEACION!G9","v":1},{"$f":"IF(E33>=50%,1,0)","v":1},{"$f":"IF(SUM(C33,E33)>=100%,100%,SUM(C33,E33))","v":1},{"$f":"IF(G33=100%,1,0)","v":1}]

{"sheet":"ANALISIS","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[11,4,17,4],[18,4,19,4],[18,2,19,2],[18,3,19,3],[7,2,9,2],[7,3,9,3],[11,2,17,2],[11,3,17,3]]}
[]
[null,null,"AREA","BSC ACTUALIZADO A DICIEMBRE ","ANALISIS"]
[null,null,"PLANEACIÓN","OK","Se realizó el Plan de Acción 2019 con su respectivos seguimientos trimestrales, así mismo se construyó entre todas las áreas de la empresa el Plan estratégico 2019-2022 , lo cual da un cumplimiento del 100% en sus indicadores"]
[null,null,"CONTROL INTERNO","OK","El área cuenta con una programación anual de los informes de ley y auditorias que deben presentar, por lo tanto los respectivos informes y  auditorias se cargan y generan en la fecha indicada, al igual todos los planes de mejoramiento  y los informes a entes externos se cumplieron en un 100%"]
[null,null,"PRODUCCION","OK","Los indicadores se cumplen con satisfacción en fechas de bajas ventas el indicador de producción es bajo, pero acorde al plan anual de producción, ya que el mayor porcentaje se ejecuta a final de año tal y como se aprecia en el BSC se cumplió a satisfacción."]
[null,null,"CONTROL DE CALIDAD","OK","Los indicadores se cumplen con satisfacción a la fecha, es de resaltar que el indicador de reclamos y de producto no conforme son minimos y de casi un 0%"]
[null,null,"FINANCIERA","OK","el margen operacional se empezó a ver  en forma positiva desde el mes de agosto de 2019, este indicador donde tuvo en mejor comportamiento como es natural en el mes de diciembre, ya que las ventas se concentran en mas de un 30%, lo que nos indica que el negocio es muy lucrativo."]
[null,null,"ADMINISTRATIVA","OK","Se cumple con los tiempos maximos de bodegaje o mas exactamente con el maximo de cajas permitido para almacenamiento de producto ya facturado por los clientes en cada mes, pero como se puede apreciar solo se tuvo prodcuto de los distribuidores durante el primer trimestre."]
[null,null,null,null,"las actividades planeadas para el sistema de Gestión y seguridad en el trabajo se cumplieron en un 97% debido a No se cumplió con el 100% porque no conto con un Profesional de la Psicología para llevar a cabo la bateria de Riesgo Psicosocial. No se pudo terminar lo del Plan de Emergencias y faltó el plan de mejoramiento para analisis de ausentismo laboral. Los cuales se incluiran en el Plan de Seguridad y Salud en el tarbajo (SG-SST) de la vigencia 2020."]
[null,null,null,null,"A 31 de diciembre de 2019, se cumplió parcialmente con el Plan de Capacitación con un porcentaje del  82% , de una meta del 100%. No se cumplió el 100%, por cuanto hubo necesidades de capacitación que no se conto en nuetro medio como llevarlas a cabo. En caso de requerirse se incluirán en el Plan de Capacitación y Formacion 2020."]
[null,null,"JURIDICA","OK","en la división Juridica se cumple a satisfacción con el indicador para llevar a cabo la contratción de la empresa y todo los contratos solicitados por la administración se realizaron durante el año 2019"]
[null,null,"COMERCIALIZACION","OK","uno de los indicadores mas importantes para la empresa como es el de ventas se cumplió en un 100%, los reclamos en cuanto al producto se respondieron en su totalidad y son minimos como se mencionó anteriormente en el BSC de Control de Calidad. En cuanto a la consumidores satisfechos se realizaron dos encuesta en el año que están por encima de la meta del 80%, cumpliendo con el buen servicio al cliente y resolviendo las peticiones, quejas y reclamos en los tiempos adecuados."]
[]
[]
[]
[]
[]
[]
[null,null,"GESTIÓN TECNOLOGICA","OK","se cumple con todos los requerimientos de los funcionarios para soporte tecnico de los equipo y el mantenimiento a los mismo según el indicador del año 2019 que se cumple en un 100% "]

{"sheet":"PLANEACION","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[4,0,4,6],[6,0,7,0],[6,6,7,6],[6,4,7,4],[6,2,7,2],[0,0,3,0],[0,1,0,6],[1,1,1,6],[2,1,3,1],[2,2,3,2],[2,3,3,4],[2,5,3,6],[8,4,9,4],[8,6,9,6],[8,1,9,1],[11,0,12,0],[11,1,12,1],[8,0,9,0],[8,2,9,2]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03","Versión\n04","Fecha vigencia\nJulio 16 de 2018",null,"Página \n12 de 13"]
[]
["PLANEACIÓN"]
["NOMBRE","FORMULA ","META","1S","%","2S","%"]
["PROYECTOS","Número de Planes Ejecutados ",">=90%",3,{"$f":"D7/D8","v":1},3,{"$f":"F7/F8","v":1}]
[null," Número de Planes Elaborados",null,3,null,3]
["FORMULACION PLAN ESTRATEGICO 2019-2022","Avances",1,1,{"$f":"D9/D10","v":1},1,{"$f":"F9/F10","v":1}]
[null,null,null,1,null,1]
[]
["RESPONSABLE","Jefe División planeación."]

{"sheet":"ADMINISTRATIVA","index":4,"n_rows":14,"n_cols":27,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,3,10,12],[11,3,11,12],[10,15,10,24],[11,15,11,24],[10,13,11,14],[6,2,7,2],[8,2,9,2],[10,0,11,0],[10,2,11,2],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26],[6,26,7,26],[4,0,4,26],[6,0,7,0],[6,4,7,4],[6,6,7,6],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[8,24,9,24],[8,26,9,26],[13,0,14,0],[13,1,14,1],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,0,9,0],[8,4,9,4],[8,6,9,6],[8,8,9,8],[8,10,9,10],[10,25,11,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["ALMACENAMIENTO CLIENTES","uds Cliente Bodega","<=33%",182556,{"$f":"D7/D8","v":0.20283999999999999},123960,{"$f":"F7/F8","v":0.13773333333333335},112854,{"$f":"H7/H8","v":0.12539333333333333},97452,{"$f":"J7/J8","v":0.10828},93918,{"$f":"L7/L8","v":0.10435333333333334},82974,{"$f":"N7/N8","v":9.2193333333333335E-2},54540,{"$f":"P7/P8","v":6.0600000000000001E-2},39861,{"$f":"R7/R8","v":4.4290000000000003E-2},29658,{"$f":"T7/T8","v":3.2953333333333334E-2},26520,{"$f":"V7/V8","v":2.9466666666666665E-2},34281,{"$f":"X7/X8","v":3.8089999999999999E-2},297000,{"$f":"Z7/Z8","v":0.33}]
[null,"# uds Bodega",null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000,null,900000]
["SGSST","Actividades del SGSST ejecutadas",1,5,{"$f":"D9/D10","v":1},5,{"$f":"F9/F10","v":1},9,{"$f":"H9/H10","v":1},7,{"$f":"J9/J10","v":1},21,{"$f":"L9/L10","v":1},15,{"$f":"N9/N10","v":0.78947368421052633},8,{"$f":"P9/P10","v":1},16,{"$f":"R9/R10","v":1},16,{"$f":"T9/T10","v":0.88888888888888884},15,{"$f":"V9/V10","v":1},12,{"$f":"X9/X10","v":0.8571428571428571},15,{"$f":"(Z9+X9+V9+T9+R9+P9+N9+L9+J9+H9+F9+D9)/(D10+F10+J10+L10+N10+P10+R10+T10+V10+X10+Z10)","v":0.96644295302013428}]
[null,"Actividades del SGSST programadas",null,5,null,5,null,9,null,7,null,21,null,19,null,8,null,16,null,18,null,15,null,14,null,21]
["CAPACITACION","Total eventos de capacitación y formación realizados",1,17,null,null,null,null,null,null,null,null,null,{"$f":"D11/D12","v":0.5},null,11,null,null,null,null,null,null,null,null,null,{"$f":"P11/P12","v":0.3235294117647059}]
[null,"Total eventos de capacitación y formación programados",null,34,null,null,null,null,null,null,null,null,null,null,null,34]
[]
["RESPONSABLE","Jefe division Administrativa"]

{"sheet":"PRODUCCION","index":5,"n_rows":15,"n_cols":28,"rows_kept":15,"cut":false,"hidden":false,"merged":[[14,0,15,0],[14,1,15,1],[12,11,13,11],[5,0,5,27],[4,0,4,16383],[7,26,8,26],[7,27,8,27],[7,0,8,0],[7,2,8,2],[7,4,8,4],[7,6,8,6],[7,8,8,8],[7,10,8,10],[7,12,8,12],[7,14,8,14],[7,16,8,16],[7,18,8,18],[7,20,8,20],[7,22,8,22],[7,24,8,24],[10,22,11,22],[10,24,11,24],[10,26,11,26],[10,0,11,0],[10,12,11,12],[10,14,11,14],[10,16,11,16],[10,18,11,18],[10,20,11,20],[10,2,11,2],[10,4,11,4],[10,6,11,6],[10,8,11,8],[10,10,11,10],[0,0,3,0],[0,1,0,27],[1,1,1,27],[2,1,3,2],[2,3,3,7],[2,8,3,12],[2,13,3,17],[2,18,3,27]]}
[null," INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,"Página \n2 de 13"]
[]
[]
["PRODUCCIÓN"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["PRODUCION","Total     Unidades     producidas",1,0,{"$f":"D8/D$9","v":0},20510,{"$f":"F8/F$9","v":3.1075757575757576E-2},137102,{"$f":"H8/H$9","v":0.31958508158508159},135732,{"$f":"J8/J$9","v":0.32133522727272729},{"$f":"(6331+11513+1161)*12","v":228060},{"$f":"L8/L$9","v":0.33410685090448816},{"$f":"(13679+2230+9042)*12","v":299412},{"$f":"N8/N$9","v":0.99804000000000004},{"$f":"((11433+9563+12570)*12)+(5769*14)","v":483558},{"$f":"P8/P$9","v":0.98765931372549021},{"$f":"(5888+24310)*12","v":362376},{"$f":"R8/R$9","v":0.80706630675895985},{"$f":"(6446+14363+11261)*12","v":384840},{"$f":"T8/T$9","v":11.661818181818182},342636,{"$f":"V8/V$9","v":1},{"$f":"(13820+772+9276)*12","v":286416},{"$f":"X8/X$9","v":1},417246,{"$f":"Z8/Z$9","v":1},{"$f":"AVERAGE(E8,G8,I8,K8,M8,O8,Q8,S8,U8,W8,Y8,AA8)","v":1.5383905599700574}]
[null,"Total de Unidades Programadas",null,11200,null,660000,null,429000,null,422400,null,682596,null,300000,null,{"$f":"40800*12","v":489600},null,{"$f":"(29500+7917)*12","v":449004},null,{"$f":"2750*12","v":33000},null,342636,null,286416,null,417246]
[]
["REDUCIR EL IMPACTO AMBIENTAL EN EL MANEJO DE LOS RESIDUOS DE LA PRODUCCIÓN","Total de Bajas (Etiqueta, Tapa, Cartón) Año Actual ","<1,5%",15,{"$f":"D11/D12","v":{"$error":"#DIV/0!"}},{"$f":"41+309+28+31","v":409},{"$f":"F11/F12","v":1.9941491955143831E-2},{"$f":"6+28+64+81+197+592+5+11+15+34+18+292+47","v":1390},{"$f":"H11/H12","v":1.0138437076045573E-2},{"$f":"117+144+140+53+49+1+7+64","v":575},{"$f":"J11/J12","v":4.2362891580467387E-3},{"$f":"235+12+413+472+54+63+54+8+56+11+101+53","v":1532},{"$f":"L11/L12","v":6.7175304744365519E-3},{"$f":"115+97+474+222+102+65+49+5+22+211+30","v":1392},{"$f":"N11/N12","v":4.6491122600296579E-3},{"$f":"202+92+26+384+255+147+342+71+32+39+26+282+71+35","v":2004},{"$f":"P11/P12","v":4.1442805206407503E-3},{"$f":"247+450+166+51+92+43+120","v":1169},{"$f":"R11/R12","v":3.2259310771132746E-3},{"$f":"156+81+295+138+112+50+83+45+109+63","v":1132},{"$f":"T11/T12","v":2.9414821744101444E-3},{"$f":"156+10+1521+128+99+11+36+29+40+265+11","v":2306},{"$f":"V11/V12","v":6.7301742957540951E-3},{"$f":"23+253+20+748+42+273+5+82+2+34+177+96","v":1755},{"$f":"X11/X12","v":6.1274509803921568E-3},{"$f":"296+37+3+3+161+28+404+34+462+144+57+98+1+40+5+39+87+9","v":1908},{"$f":"Z11/Z12","v":4.5728419205936068E-3}]
[null,"Total Unidades Producidas",null,0,null,{"$f":"F8","v":20510},null,{"$f":"H8","v":137102},null,{"$f":"J8","v":135732},null,{"$f":"L8","v":228060},null,{"$f":"N8","v":299412},null,{"$f":"P8","v":483558},null,{"$f":"R8","v":362376},null,{"$f":"T8","v":384840},null,{"$f":"V8","v":342636},null,{"$f":"X8","v":286416},null,{"$f":"Z8","v":417246}]
[]
[]
["RESPONSABLE","Jefe División Producción"]

{"sheet":"GESTION DE CALIDAD","index":6,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":true,"merged":[[11,0,12,0],[11,1,12,1],[4,0,4,26],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,0,7,0],[6,4,7,4],[6,6,7,6],[6,8,7,8],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[6,26,7,26],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26],[6,1,7,1],[8,0,9,0],[8,1,9,1],[8,4,9,4],[8,6,9,6],[6,2,9,2],[8,8,9,8],[8,10,9,10],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,24,9,24],[8,26,9,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["ESTADO DE ACCIONES CORRECTIVAS"," No conformidades de auditoria interna cerradas / Total no conformidades de auditoria interna ",">=70%",0,{"$f":"D7/D8","v":{"$error":"#DIV/0!"}},0,{"$f":"F7/F8","v":{"$error":"#DIV/0!"}},0,{"$f":"H7/H8","v":{"$error":"#DIV/0!"}},0,{"$f":"J7/J8","v":{"$error":"#DIV/0!"}},0,{"$f":"L7/L8","v":{"$error":"#DIV/0!"}},0,{"$f":"N7/N8","v":{"$error":"#DIV/0!"}},0,{"$f":"P7/P8","v":{"$error":"#DIV/0!"}},0,{"$f":"R7/R8","v":{"$error":"#DIV/0!"}},0,{"$f":"T7/T8","v":{"$error":"#DIV/0!"}},0,{"$f":"V7/V8","v":{"$error":"#DIV/0!"}},0,{"$f":"X7/X8","v":{"$error":"#DIV/0!"}},52,{"$f":"Z7/Z8","v":1}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,52]
["AUDITORIA INTERNA"," Auditoria interna realizadas/Total auditorías internas programadas",null,0,{"$f":"D9/D10","v":{"$error":"#DIV/0!"}},0,{"$f":"F9/F10","v":{"$error":"#DIV/0!"}},0,{"$f":"H9/H10","v":{"$error":"#DIV/0!"}},3,{"$f":"J9/J10","v":{"$error":"#DIV/0!"}},5,{"$f":"L9/L10","v":{"$error":"#DIV/0!"}},2,{"$f":"N9/N10","v":{"$error":"#DIV/0!"}},2,{"$f":"P9/P10","v":{"$error":"#DIV/0!"}},0,{"$f":"R9/R10","v":{"$error":"#DIV/0!"}},0,{"$f":"T9/T10","v":{"$error":"#DIV/0!"}},0,{"$f":"V9/V10","v":{"$error":"#DIV/0!"}},0,{"$f":"X9/X10","v":{"$error":"#DIV/0!"}},2,{"$f":"Z9/Z10","v":1}]
[null,null,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,2]
[]
["RESPONSABLE","Representante de la Dirección Coordinador de Calidad"]

{"sheet":"COMUNICACION","index":7,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":true,"merged":[[8,24,9,24],[8,26,9,26],[11,0,12,0],[11,1,12,1],[8,12,9,12],[8,14,9,14],[8,16,9,16],[8,18,9,18],[8,20,9,20],[8,22,9,22],[8,0,9,0],[8,1,9,1],[8,4,9,4],[8,6,9,6],[8,8,9,8],[8,10,9,10],[6,26,7,26],[4,0,4,26],[6,0,7,0],[6,1,7,1],[6,2,9,2],[6,4,7,4],[6,6,7,6],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,20],[2,21,3,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n3 de 15"]
[]
["GESTIÓN DE CALIDAD"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
[null,null,null,10,{"$f":"D7/D8","v":0.33333333333333331},null,{"$f":"F7/F8","v":{"$error":"#DIV/0!"}},null,{"$f":"H7/H8","v":{"$error":"#DIV/0!"}},null,{"$f":"J7/J8","v":{"$error":"#DIV/0!"}},null,{"$f":"L7/L8","v":{"$error":"#DIV/0!"}},null,{"$f":"N7/N8","v":{"$error":"#DIV/0!"}},null,{"$f":"P7/P8","v":{"$error":"#DIV/0!"}},null,{"$f":"R7/R8","v":{"$error":"#DIV/0!"}},null,{"$f":"T7/T8","v":{"$error":"#DIV/0!"}},null,{"$f":"V7/V8","v":{"$error":"#DIV/0!"}},null,{"$f":"X7/X8","v":{"$error":"#DIV/0!"}},null,{"$f":"Z7/Z8","v":{"$error":"#DIV/0!"}}]
[null,null,null,30]
[null,null,null,0,{"$f":"D9/D10","v":0},0,{"$f":"F9/F10","v":0},0,{"$f":"H9/H10","v":0},0,{"$f":"J9/J10","v":0},0,{"$f":"L9/L10","v":0},6,{"$f":"N9/N10","v":0.46153846153846156},null,{"$f":"P9/P10","v":0},null,{"$f":"R9/R10","v":0},null,{"$f":"T9/T10","v":0},null,{"$f":"V9/V10","v":0},null,{"$f":"X9/X10","v":0},null,{"$f":"Z9/Z10","v":0}]
[null,null,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13,null,13]
[]
["RESPONSABLE"]

{"sheet":"MANTENIMIENTO","index":8,"n_rows":16,"n_cols":27,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,0,16,0],[15,1,16,1],[6,20,7,20],[6,22,7,22],[6,6,7,6],[10,0,11,0],[10,2,11,2],[6,4,7,4],[10,4,11,4],[6,14,7,14],[6,16,7,16],[6,18,7,18],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,15],[2,16,3,26],[4,0,4,26],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,0,7,0],[6,2,7,2],[6,24,7,24],[6,26,7,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n4 de 13"]
[]
["MANTENIMIENTO"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["% DISPONIBILIDAD","     Tiempo Total de Operación","69%  o menor:Malo                                             70% - 79% : Regular                                          80% - 89%  : Bueno                                           90% - 94% : Optimo                                            95% - 100% : Fuera de rango posible",1,{"$f":"D7/D8","v":1},1845,{"$f":"F7/F8","v":0.67458866544789764},5870,{"$f":"H7/H8","v":0.79057239057239059},6820,{"$f":"J7/J8","v":0.78871284838672373},11960,{"$f":"L7/L8","v":0.88566350710900477},11425,{"$f":"N7/N8","v":0.838409040874734},13835,{"$f":"P7/P8","v":0.9104968739717012},9785,{"$f":"R7/R8","v":0.87124922090641976},11840,{"$f":"T7/T8","v":0.89568045994402001},13145,{"$f":"V7/V8","v":0.82418960436390998},11175,{"$f":"X7/X8","v":0.83314694699172442},12325,{"$f":"Z7/Z8","v":0.8910497397339503}]
[null,"Tiempo de Operación + Tiempo de paradas",null,1,null,{"$f":"1845+890","v":2735},null,{"$f":"5870+1555","v":7425},null,{"$f":"6820+1827","v":8647},null,{"$f":"11960+1544","v":13504},null,{"$f":"11425+2202","v":13627},null,{"$f":"13835+1360","v":15195},null,{"$f":"9785+1446","v":11231},null,{"$f":"11840+1379","v":13219},null,{"$f":"13145+2804","v":15949},null,{"$f":"11175+2238","v":13413},null,{"$f":"12325+1507","v":13832}]
[]
["NOMBRE","FORMULA ","META","Año","%"]
["COSTO TOTAL DE MANTENIMIENTO POR FACTURACIÓN"," Costo Total de Mto por Facturación","<= 2% de la facturacion",364832138,{"$f":"D11/D12","v":2.3458119150589953E-3},"Costo de los proyectos ejecutados en el año necesarios para el mantenimiento de la infraestructura de producción y compras de nuevos equipos."]
[null,"Facturación Total en el periodo",null,155524889126,null,"Facturación del año 2019 sin incluir impuestos"]
[]
[]
[]
["RESPONSABLE","Profesional Universitario de Mantenimiento"]

{"sheet":"CONTROL INTERNO","index":9,"n_rows":22,"n_cols":27,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,0,22,0],[21,1,22,1],[4,0,4,26],[6,8,7,8],[6,10,7,10],[6,12,7,12],[6,14,7,14],[6,16,7,16],[6,18,7,18],[6,20,7,20],[6,22,7,22],[6,24,7,24],[6,26,7,26],[6,2,7,2],[6,0,7,0],[6,4,7,4],[6,6,7,6],[10,10,11,10],[10,0,11,0],[10,2,11,2],[10,4,11,4],[10,6,11,6],[10,8,11,8],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,15],[2,16,3,26],[10,14,11,14],[14,0,15,0],[14,2,15,2],[14,4,15,4],[14,6,15,6],[14,8,15,8],[14,10,15,10],[14,12,15,12],[14,14,15,14],[18,0,19,0],[18,2,19,2],[18,4,19,4],[18,6,19,6],[10,12,11,12]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n5 de 15"]
[]
["CONTROL INTERNO"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["AUDITORIA INTERNA ","Numero de auditorías de Control Interno realizadas en el Programa Anual de Auditorias ",">=80%",0,{"$f":"D7/$D$8","v":0},0,null,0,{"$f":"H7/$D$8","v":0},4,{"$f":"J7/$D$8","v":0.33333333333333331},4,{"$f":"L7/$D$8","v":0.33333333333333331},4,{"$f":"N7/$D$8","v":0.33333333333333331},null,{"$f":"P7/$D$8","v":0},0,{"$f":"R7/$D$8","v":0},0,{"$f":"T7/$D$8","v":0},0,{"$f":"V7/$D$8","v":0},0,{"$f":"X7/$D$8","v":0},0,{"$f":"Z7/$D$8","v":0}]
[null,"total de auditorías de Control Interno establecidas en el Programadas Anual de Auditorias   *100",null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12,null,12]
[]
["NOMBRE","FORMULA ","META","1B","%","2B","%","3B","%","4B","%","5B","%","6B","%"]
["ENTES EXTERNOS","Numero de Informes de Ley presentados",1,7,{"$f":"D11/D12","v":1},4,{"$f":"F11/F12","v":1},0,{"$f":"H11/H12","v":{"$error":"#DIV/0!"}},4,{"$f":"J11/J12","v":1},1,{"$f":"L11/L12","v":0.5},2,{"$f":"N11/N12","v":1}]
[null,"Total de Informes de Ley a presentar",null,7,null,4,null,0,null,4,null,2,null,2]
[]
["NOMBRE","FORMULA ","META","1B","%","2B","%","3B","%","4B","%","5B","%","6B","%"]
["SIA","Nº de requerimientos publicados",1,4,{"$f":"D15/D16","v":1},2,{"$f":"F15/F16","v":1},3,{"$f":"H15/H16","v":1},3,{"$f":"J15/J16","v":1},2,{"$f":"L15/L16","v":1},1,{"$f":"N15/N16","v":1}]
[null,"Total de requerimientos en SIA Contralorías",null,4,null,2,null,3,null,3,null,2,null,1]
[]
["NOMBRE","FORMULA ","META","1S","%","2S","%"]
["PLANES DE MEJORAMIENTO","Nº de Instrumentos adoptados",1,1,{"$f":"D19/D20","v":1},1,{"$f":"F19/F20","v":1}]
[null,"Total de Instrumentos del Decreto 648/17 Art. 2.2.21.4.8",null,1,null,1]
[]
["RESPONSABLE","Jefe Oficina de Control Interno"]

{"sheet":"GESTIÓN TECNOLOGICA","index":10,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,0,11,0],[10,1,11,1],[6,24,7,24],[6,22,7,22],[6,20,7,20],[6,26,7,26],[4,0,4,26],[6,2,7,2],[6,0,7,0],[6,4,7,4],[6,8,7,8],[6,6,7,6],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,3],[2,4,3,9],[2,10,3,16],[2,17,3,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n8 de 13"]
[]
["GESTIÓN TECNOLOGICA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["SOPORTE","# de solicitudes soporte",1,63,{"$f":"D7/D8","v":1},60,{"$f":"F7/F8","v":1},60,{"$f":"H7/H8","v":1},60,{"$f":"J7/J8","v":1},66,{"$f":"L7/L8","v":1},54,{"$f":"N7/N8","v":1},66,{"$f":"P7/P8","v":1},60,{"$f":"R7/R8","v":1},63,{"$f":"T7/T8","v":1},66,{"$f":"V7/V8","v":1},57,{"$f":"X7/X8","v":1},63,{"$f":"Z7/Z8","v":1}]
[null,"# Total de solicitudes recibidas",null,63,null,60,null,60,null,60,null,66,null,54,null,66,null,60,null,63,null,66,null,57,null,63]
[]
[]
["RESPONSABLE","Técnico Programador de Sistemas "]

{"sheet":"COMERCIALIZACIÓN","index":11,"n_rows":17,"n_cols":28,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,27,10,27],[12,0,13,0],[12,2,13,2],[12,4,13,4],[12,6,13,6],[12,8,13,8],[12,10,13,10],[12,12,13,12],[12,14,13,14],[12,16,13,16],[12,18,13,18],[12,20,13,20],[12,22,13,22],[12,24,13,24],[12,26,13,26],[12,27,13,27],[9,18,10,18],[9,20,10,20],[9,22,10,22],[9,24,10,24],[9,26,10,26],[9,8,10,8],[9,10,10,10],[9,12,10,12],[9,14,10,14],[9,16,10,16],[16,0,17,0],[16,1,17,1],[6,20,7,20],[6,2,7,2],[6,4,7,4],[6,6,7,6],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,18,7,18],[6,16,7,16],[6,14,7,14],[9,0,10,0],[9,2,10,2],[9,4,10,4],[9,6,10,6],[0,0,3,0],[0,1,0,27],[1,1,1,27],[2,1,3,3],[2,4,3,9],[2,10,3,16],[2,17,3,27],[6,27,7,27],[4,0,4,27],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,0,7,0]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,null,"Página \n9 de 13"]
[]
["COMERCIALIZACIÓN"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["VENTAS","Número de unidades vendidas",1,0,{"$f":"D7/D8","v":0},30079,{"$f":"F7/F8","v":9.3996875000000001E-3},119382,{"$f":"H7/H8","v":3.7306875000000003E-2},304696,{"$f":"J7/J8","v":9.5217499999999997E-2},522044,{"$f":"L7/L8","v":0.16313875},792391,{"$f":"N7/N8","v":0.24762218750000001},1065180,{"$f":"P7/P8","v":0.33286874999999999},1352389,{"$f":"R7/R8","v":0.42262156249999999},1553611,{"$f":"T7/T8","v":0.48550343750000002},1880945,{"$f":"V7/V8","v":0.58779531249999994},2173023,{"$f":"X7/X8","v":0.67906968749999996},3205295,{"$f":"Z7/Z8","v":1.0016546875000001},{"$f":"Z7/Z8","v":1.0016546875000001}]
[null,"total meta de ventas",null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000,null,3200000]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["RECLAMOS","No. Clientes satisfechos de R",0.8,1,{"$f":"D10/D11","v":1},2,{"$f":"F10/F11","v":1},6,{"$f":"H10/H11","v":1},3,{"$f":"J10/J11","v":1},7,{"$f":"L10/L11","v":1},3,{"$f":"N10/N11","v":1},12,{"$f":"P10/P11","v":1},0,{"$f":"R10/R11","v":{"$error":"#DIV/0!"}},1,{"$f":"T10/T11","v":1},9,{"$f":"V10/V11","v":1},10,{"$f":"X10/X11","v":1},7,{"$f":"Z10/Z11","v":1},1]
[null,"No. R presentados.",null,1,null,2,null,6,null,3,null,7,null,3,null,12,null,0,null,1,null,9,null,10,null,7]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%","Año"]
["SATISFACCION","No. Consumidores satisfechos",0.8,null,{"$f":"D13/D14","v":{"$error":"#DIV/0!"}},null,{"$f":"F13/F14","v":{"$error":"#DIV/0!"}},null,{"$f":"H13/H14","v":{"$error":"#DIV/0!"}},null,{"$f":"J13/J14","v":{"$error":"#DIV/0!"}},null,{"$f":"L13/L14","v":{"$error":"#DIV/0!"}},50,{"$f":"N13/N14","v":1},null,{"$f":"P13/P14","v":{"$error":"#DIV/0!"}},null,{"$f":"R13/R14","v":{"$error":"#DIV/0!"}},null,{"$f":"T13/T14","v":{"$error":"#DIV/0!"}},null,{"$f":"V13/V14","v":{"$error":"#DIV/0!"}},null,{"$f":"X13/X14","v":{"$error":"#DIV/0!"}},18,0.69,0.89]
[null,"total consumidores encuestados",null,null,null,null,null,null,null,null,null,null,null,50,null,null,null,null,null,null,null,null,null,null,null,26]
[]
[]
["RESPONSABLE","Jefe División Comercialización"]

{"sheet":"JURIDICA","index":12,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[6,22,7,22],[10,0,11,0],[10,1,11,1],[4,0,4,26],[6,0,7,0],[6,2,7,2],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,6,7,6],[6,4,7,4],[6,20,7,20],[6,18,7,18],[6,16,7,16],[6,26,7,26],[6,24,7,24],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,3],[2,4,3,8],[2,9,3,14],[2,15,3,26]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n11 de 15"]
[]
["JURIDICA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["CONTRATOS OPORTUNOS","Número de contratos realizados ",1,107,{"$f":"D7/D8","v":1},30,{"$f":"F7/F8","v":1},18,{"$f":"H7/H8","v":1},23,{"$f":"J7/J8","v":1},15,{"$f":"L7/L8","v":1},46,{"$f":"N7/N8","v":1},22,1,15,1,13,1,30,1,21,1,5,1]
[null," Números de contratos solicitados",null,107,null,30,null,18,null,23,null,15,null,46,null,22,null,15,null,13,null,30,null,21,null,5]
[]
[]
["RESPONSABLE","Jefe División Juridica"]

{"sheet":"FINANCIERA","index":13,"n_rows":11,"n_cols":27,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,8,3,13],[2,14,3,26],[10,0,11,0],[10,1,11,1],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,7],[6,6,7,6],[4,0,4,26],[6,2,7,2],[6,0,7,0],[6,4,7,4],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,20,7,20]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n13 de 13"]
[]
["ADMINISTRATIVA Y FINANCIERA"]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Agos","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["MARGEN OPERACIONAL","Utilidad Operacional",">=17%",null,{"$f":"D7/D8","v":{"$error":"#DIV/0!"}},1700584,{"$f":"F7/F8","v":4.7988396439919407},1914587,{"$f":"H7/H8","v":1.3668240578658952},1354209,{"$f":"J7/J8","v":0.37286537232047817},438557,{"$f":"L7/L8","v":6.971558941598964E-2},-165787043,{"$f":"N7/N8","v":-1.6922716543432567E-2},454991379,{"$f":"P7/P8","v":3.4427806807830558E-2},1199972381,{"$f":"R7/R8","v":7.140994074981323E-2},2061263647,{"$f":"T7/T8","v":0.10688355931691895},3495333473,{"$f":"V7/V8","v":0.14928610549871199},4788252193,{"$f":"X7/X8","v":0.17612968106950672},10435529682,{"$f":"+Z7/Z8","v":0.26075781570378248}]
[null,"Ingresos Netos",null,null,null,354374,null,1400756,null,3631898,null,6290659,null,9796715709,null,13215810741,null,16803996312,null,19285132907,null,23413655687,null,27185947104,null,40020007277]
[]
[]
["RESPONSABLE","Jefe División\nFinanciera."]

{"sheet":"CONTROL DE CALIDAD","index":14,"n_rows":26,"n_cols":27,"rows_kept":26,"cut":false,"hidden":false,"merged":[[13,0,14,0],[13,1,14,1],[0,0,3,0],[0,1,0,26],[1,1,1,26],[2,1,3,2],[2,3,3,8],[2,9,3,14],[2,15,3,26],[6,0,7,0],[9,0,10,0],[9,2,10,2],[6,2,7,2],[9,8,10,8],[9,6,10,6],[9,4,10,4],[6,6,7,6],[9,18,10,18],[9,16,10,16],[9,14,10,14],[9,12,10,12],[9,10,10,10],[4,0,4,26],[9,26,10,26],[9,24,10,24],[9,22,10,22],[9,20,10,20],[6,26,7,26],[6,24,7,24],[6,22,7,22],[6,20,7,20],[6,18,7,18],[6,16,7,16],[6,14,7,14],[6,12,7,12],[6,10,7,10],[6,8,7,8],[6,4,7,4]]}
[null,"INDUSTRIA LICORERA DEL CAUCA 2019"]
[null,"BALANCE SCORECARD"]
[null,"Código\nDOPL03",null,"Versión\n04",null,null,null,null,null,"Fecha vigencia\nJulio 16 de 2018",null,null,null,null,null,"Página \n15 de 13"]
[]
["CONTROL DE CALIDAD"]
["NOMBRE","FORMULA ","META",null,"%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["RECLAMOS ATENDIDOS","Concepto tecnico  ",1,1,{"$f":"D7/D8","v":1},4,{"$f":"F7/F8","v":1},4,{"$f":"H7/H8","v":1},4,{"$f":"J7/J8","v":1},8,{"$f":"L7/L8","v":1},2,{"$f":"N7/N8","v":1},9,{"$f":"P7/P8","v":1},0,{"$f":"R7/R8","v":{"$error":"#DIV/0!"}},5,{"$f":"T7/T8","v":1},15,{"$f":"V7/V8","v":1},4,{"$f":"X7/X8","v":1},5,{"$f":"Z7/Z8","v":1}]
[null,"Total reclamos recibidos en el mes",null,1,null,4,null,4,null,4,null,8,null,2,null,9,null,0,null,5,null,15,null,4,null,5]
["NOMBRE","FORMULA ","META","Ene","%","Feb","%","Mar","%","Abr","%","May","%","Jun","%","Jul","%","Ago","%","Sep","%","Oct","%","Nov","%","Dic","%"]
["PRODUCTOS NO CONFORMES","Numero De Productos no conformes ","<=3%",0,0,679,{"$f":"F10/F11","v":7.6723163841807912E-2},961,{"$f":"H10/H11","v":9.784755737471236E-3},1736,{"$f":"J10/J11","v":8.9871818765401429E-3},968,{"$f":"L10/L11","v":3.1838753815387854E-3},994,{"$f":"N10/N11","v":2.1442747432910518E-3},1621,{"$f":"P10/P11","v":2.8470663449007478E-3},1074,{"$f":"R10/R11","v":2.4801862218034694E-3},735,{"$f":"T10/T11","v":1.590248208536712E-3},1235,{"$f":"V10/V11","v":2.0254999786789474E-3},4064,{"$f":"X10/X11","v":8.9860609920045277E-3},1309,{"$f":"Z10/Z11","v":3.073159508482296E-3}]
[null,"Lotes de PT",null,0,null,8850,null,98214,null,193164,null,304032,null,463560,null,569358,null,433032,null,462192,null,609726,null,452256,null,425946]
[]
[]
["RESPONSABLE","Profesional Universitario Control Calidad"]
[]
[]
[]
[]
[]
[]
[]
[null,"Incremento en el porcentaje debido a el mantenimiento, ajustes y ensayo de los equipos de la linea "]
[null,"no se recepciono reclamos "]
[]
[]
[null,"No se recepcionaron reclamos en ese periodo de tiempo"]